/*
 Navicat Premium Data Transfer

 Source Server         : root
 Source Server Type    : MySQL
 Source Server Version : 80300 (8.3.0)
 Source Host           : localhost:3306
 Source Schema         : pet_adoption

 Target Server Type    : MySQL
 Target Server Version : 80300 (8.3.0)
 File Encoding         : 65001

 Date: 26/05/2025 21:51:39
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for adoption_applications
-- ----------------------------
DROP TABLE IF EXISTS `adoption_applications`;
CREATE TABLE `adoption_applications` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL COMMENT '提交领养申请的用户的唯一标识符',
  `pet_id` int NOT NULL COMMENT '被申请领养的宠物的唯一标识符',
  `status` enum('pending','approved','rejected') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '领养申请的状态：待处理、已批准或已拒绝',
  `application_date` timestamp NULL DEFAULT NULL COMMENT '提交领养申请的日期和时间',
  `approval_date` timestamp NULL DEFAULT NULL COMMENT '领养申请被批准的日期和时间（如果适用）',
  `reason_for_adoption` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '申请人提供领养该宠物的原因',
  `living_situation` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '申请人的居住环境描述',
  `previous_pet_experience` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '申请人之前的养宠经历（如果有）',
  `additional_notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '其他补充信息或备注',
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_user_pet` (`user_id`,`pet_id`),
  KEY `pet_id` (`pet_id`),
  CONSTRAINT `adoption_applications_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
  CONSTRAINT `adoption_applications_pet_id_fk_cascade` FOREIGN KEY (`pet_id`) REFERENCES `pets` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of adoption_applications
-- ----------------------------
BEGIN;
INSERT INTO `adoption_applications` (`id`, `user_id`, `pet_id`, `status`, `application_date`, `approval_date`, `reason_for_adoption`, `living_situation`, `previous_pet_experience`, `additional_notes`) VALUES (1, 9, 11, 'approved', '2025-04-28 10:00:18', '2025-05-15 14:51:55', '111111111111111111', 'own', NULL, NULL);
INSERT INTO `adoption_applications` (`id`, `user_id`, `pet_id`, `status`, `application_date`, `approval_date`, `reason_for_adoption`, `living_situation`, `previous_pet_experience`, `additional_notes`) VALUES (3, 9, 12, 'approved', '2025-05-15 23:51:39', '2025-05-15 21:16:25', '1111111111111', '111111111111111', '1111111111111', '111111111111111');
INSERT INTO `adoption_applications` (`id`, `user_id`, `pet_id`, `status`, `application_date`, `approval_date`, `reason_for_adoption`, `living_situation`, `previous_pet_experience`, `additional_notes`) VALUES (16, 10, 12, 'approved', '2025-05-15 23:51:39', '2025-05-16 01:22:35', '111111111111111', '11111111111111111', '111111111111111111111', '111111111111111111111');
INSERT INTO `adoption_applications` (`id`, `user_id`, `pet_id`, `status`, `application_date`, `approval_date`, `reason_for_adoption`, `living_situation`, `previous_pet_experience`, `additional_notes`) VALUES (17, 10, 10, 'rejected', '2025-05-15 23:51:39', NULL, '1111111111111', '1111111111111111', '1111111111111111', '111111111111111111');
INSERT INTO `adoption_applications` (`id`, `user_id`, `pet_id`, `status`, `application_date`, `approval_date`, `reason_for_adoption`, `living_situation`, `previous_pet_experience`, `additional_notes`) VALUES (18, 12, 8, 'approved', '2025-05-15 23:51:39', '2025-05-15 23:48:05', '111111111111', '1111111111111', NULL, NULL);
INSERT INTO `adoption_applications` (`id`, `user_id`, `pet_id`, `status`, `application_date`, `approval_date`, `reason_for_adoption`, `living_situation`, `previous_pet_experience`, `additional_notes`) VALUES (20, 12, 10, 'rejected', '2025-05-15 23:51:39', NULL, '1111111111', '1111111111', NULL, NULL);
INSERT INTO `adoption_applications` (`id`, `user_id`, `pet_id`, `status`, `application_date`, `approval_date`, `reason_for_adoption`, `living_situation`, `previous_pet_experience`, `additional_notes`) VALUES (22, 2, 15, 'approved', '2025-05-26 13:47:56', '2025-05-26 21:49:03', '12311111111', '12311111111', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for adoption_records
-- ----------------------------
DROP TABLE IF EXISTS `adoption_records`;
CREATE TABLE `adoption_records` (
  `id` int NOT NULL COMMENT '唯一标识符',
  `application_id` int NOT NULL COMMENT '领养申请ID',
  `adoption_date` timestamp NULL DEFAULT NULL COMMENT '领养日期',
  `adoption_fee` decimal(10,2) DEFAULT NULL COMMENT '领养费用',
  `contract_details` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '合同详情',
  `follow_up_date` timestamp NULL DEFAULT NULL COMMENT '跟进日期',
  `follow_up_notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '跟进备注',
  PRIMARY KEY (`id`),
  KEY `application_id` (`application_id`),
  CONSTRAINT `adoption_records_ibfk_1` FOREIGN KEY (`application_id`) REFERENCES `adoption_applications` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of adoption_records
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for categories
-- ----------------------------
DROP TABLE IF EXISTS `categories`;
CREATE TABLE `categories` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `description` text,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of categories
-- ----------------------------
BEGIN;
INSERT INTO `categories` (`id`, `name`, `description`, `created_at`, `updated_at`) VALUES (1, '猫咪', '包括各种品种的猫', '2025-05-15 20:50:09', '2025-05-15 20:50:09');
INSERT INTO `categories` (`id`, `name`, `description`, `created_at`, `updated_at`) VALUES (2, '狗狗', '包括各种品种的狗', '2025-05-15 20:50:09', '2025-05-15 20:50:09');
INSERT INTO `categories` (`id`, `name`, `description`, `created_at`, `updated_at`) VALUES (3, '兔子', '包括各种品种的兔子', '2025-05-15 20:50:09', '2025-05-15 20:50:09');
INSERT INTO `categories` (`id`, `name`, `description`, `created_at`, `updated_at`) VALUES (4, '鸟类', '包括各种观赏鸟类', '2025-05-15 20:50:09', '2025-05-15 20:50:09');
INSERT INTO `categories` (`id`, `name`, `description`, `created_at`, `updated_at`) VALUES (5, '小宠物', '仓鼠、豚鼠等小型宠物', '2025-05-15 20:50:09', '2025-05-15 20:50:09');
COMMIT;

-- ----------------------------
-- Table structure for pet_categories
-- ----------------------------
DROP TABLE IF EXISTS `pet_categories`;
CREATE TABLE `pet_categories` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '类别名称',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '类别描述',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of pet_categories
-- ----------------------------
BEGIN;
INSERT INTO `pet_categories` (`id`, `name`, `description`) VALUES (1, 'Dog', 'Canine companions, loyal and friendly');
INSERT INTO `pet_categories` (`id`, `name`, `description`) VALUES (2, 'Cat', 'Feline friends, independent and playful');
INSERT INTO `pet_categories` (`id`, `name`, `description`) VALUES (3, 'Bird', 'Feathered companions, colorful and melodious');
INSERT INTO `pet_categories` (`id`, `name`, `description`) VALUES (4, 'Small & Furry', 'Small mammals like hamsters, guinea pigs, and rabbits');
INSERT INTO `pet_categories` (`id`, `name`, `description`) VALUES (5, 'Reptile', 'Cold-blooded companions like snakes, lizards, and turtles');
COMMIT;

-- ----------------------------
-- Table structure for pet_comments
-- ----------------------------
DROP TABLE IF EXISTS `pet_comments`;
CREATE TABLE `pet_comments` (
  `id` int NOT NULL AUTO_INCREMENT,
  `pet_id` int NOT NULL,
  `user_id` int NOT NULL,
  `comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `rating` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `pet_id` (`pet_id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `pet_comments_ibfk_1` FOREIGN KEY (`pet_id`) REFERENCES `pets` (`id`),
  CONSTRAINT `pet_comments_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
  CONSTRAINT `pet_comments_chk_1` CHECK ((`rating` between 1 and 5))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of pet_comments
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for pets
-- ----------------------------
DROP TABLE IF EXISTS `pets`;
CREATE TABLE `pets` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `category_id` int NOT NULL,
  `breed` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `age` int DEFAULT NULL,
  `gender` enum('male','female','unknown') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `size` enum('small','medium','large','extra large') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `health_status` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `behavior` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `is_adopted` tinyint(1) DEFAULT '0',
  `image_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `category_id` (`category_id`),
  CONSTRAINT `pets_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `pet_categories` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of pets
-- ----------------------------
BEGIN;
INSERT INTO `pets` (`id`, `name`, `category_id`, `breed`, `age`, `gender`, `size`, `description`, `health_status`, `behavior`, `is_adopted`, `image_url`, `created_at`, `updated_at`) VALUES (1, 'Max', 1, 'Golden Retriever', 3, 'male', 'large', '友好的金毛，对人很友善', '已接种疫苗，健康状况良好', '活泼，喜欢与人互动', 0, 'https://images.unsplash.com/photo-1552053831-71594a27632d?ixlib=rb-1.2.1&auto=format&fit=crop&w=500&q=60', '2025-04-27 20:16:03', '2025-04-27 20:16:03');
INSERT INTO `pets` (`id`, `name`, `category_id`, `breed`, `age`, `gender`, `size`, `description`, `health_status`, `behavior`, `is_adopted`, `image_url`, `created_at`, `updated_at`) VALUES (2, 'Bella', 2, '波斯猫', 2, 'female', 'medium', '优雅的波斯猫，有着华丽的长毛', '已接种疫苗，完成绝育', '安静，温顺', 0, 'https://images.unsplash.com/photo-1518791841217-8f162f1e1131?ixlib=rb-1.2.1&auto=format&fit=crop&w=500&q=60', '2025-04-27 20:16:18', '2025-04-27 20:16:18');
INSERT INTO `pets` (`id`, `name`, `category_id`, `breed`, `age`, `gender`, `size`, `description`, `health_status`, `behavior`, `is_adopted`, `image_url`, `created_at`, `updated_at`) VALUES (3, 'Charlie', 1, '边境牧羊犬', 1, 'male', 'medium', '聪明的边牧，学习能力超强', '已接种疫苗，健康状况良好', '聪明，精力充沛', 0, 'https://images.unsplash.com/photo-1513360371669-4adf3dd7dff8?ixlib=rb-1.2.1&auto=format&fit=crop&w=500&q=60', '2025-04-27 20:16:33', '2025-04-27 20:16:33');
INSERT INTO `pets` (`id`, `name`, `category_id`, `breed`, `age`, `gender`, `size`, `description`, `health_status`, `behavior`, `is_adopted`, `image_url`, `created_at`, `updated_at`) VALUES (4, 'Lucy', 2, '英国短毛猫', 4, 'female', 'medium', '可爱的英短，有着圆圆的眼睛', '已接种疫苗，完成绝育', '友好，喜欢被抚摸', 0, 'https://images.unsplash.com/photo-1548247416-ec66f4900b2e?ixlib=rb-1.2.1&auto=format&fit=crop&w=500&q=60', '2025-04-27 20:16:49', '2025-04-27 20:16:49');
INSERT INTO `pets` (`id`, `name`, `category_id`, `breed`, `age`, `gender`, `size`, `description`, `health_status`, `behavior`, `is_adopted`, `image_url`, `created_at`, `updated_at`) VALUES (5, 'Cooper', 3, '虎皮鹦鹉', 1, 'male', 'small', '色彩鲜艳的虎皮鹦鹉', '已体检，健康状况良好', '活泼，会模仿简单的话语', 0, 'https://images.unsplash.com/photo-1555169062-013468b47731?ixlib=rb-1.2.1&auto=format&fit=crop&w=500&q=60', '2025-04-27 20:18:13', '2025-04-27 20:18:13');
INSERT INTO `pets` (`id`, `name`, `category_id`, `breed`, `age`, `gender`, `size`, `description`, `health_status`, `behavior`, `is_adopted`, `image_url`, `created_at`, `updated_at`) VALUES (6, 'Ruby', 4, '荷兰侏儒兔', 2, 'female', 'small', '可爱的小兔子，毛色漂亮', '已体检，健康状况良好', '温顺，喜欢被抚摸', 0, 'https://images.unsplash.com/photo-1585110396000-c9ffd4e4b308?ixlib=rb-1.2.1&auto=format&fit=crop&w=500&q=60', '2025-04-27 20:18:29', '2025-04-27 20:18:29');
INSERT INTO `pets` (`id`, `name`, `category_id`, `breed`, `age`, `gender`, `size`, `description`, `health_status`, `behavior`, `is_adopted`, `image_url`, `created_at`, `updated_at`) VALUES (7, 'Rocky', 5, '球蟒', 3, 'male', 'medium', '友好的球蟒，适合初学者饲养', '已体检，健康状况良好', '温顺，容易饲养', 0, 'https://images.unsplash.com/photo-1531386151447-fd76ad50012f?ixlib=rb-1.2.1&auto=format&fit=crop&w=500&q=60', '2025-04-27 20:18:47', '2025-05-13 20:02:53');
INSERT INTO `pets` (`id`, `name`, `category_id`, `breed`, `age`, `gender`, `size`, `description`, `health_status`, `behavior`, `is_adopted`, `image_url`, `created_at`, `updated_at`) VALUES (8, 'Daisy', 1, '拉布拉多', 2, 'female', 'large', '友好的拉布拉多，很适合家庭', '已接种疫苗，健康状况良好', '温顺，善良', 1, 'https://images.unsplash.com/photo-1587300003388-59208cc962cb?ixlib=rb-1.2.1&auto=format&fit=crop&w=500&q=60', '2025-04-27 20:19:12', '2025-05-15 23:48:05');
INSERT INTO `pets` (`id`, `name`, `category_id`, `breed`, `age`, `gender`, `size`, `description`, `health_status`, `behavior`, `is_adopted`, `image_url`, `created_at`, `updated_at`) VALUES (9, 'Oliver', 2, '暹罗猫', 1, 'male', 'medium', '聪明的暹罗猫，性格外向', '已接种疫苗，完成绝育', '聪明，好奇心强', 0, 'https://images.unsplash.com/photo-1541781774459-bb2af2f05b55?ixlib=rb-1.2.1&auto=format&fit=crop&w=500&q=60', '2025-04-27 20:20:07', '2025-04-27 20:20:07');
INSERT INTO `pets` (`id`, `name`, `category_id`, `breed`, `age`, `gender`, `size`, `description`, `health_status`, `behavior`, `is_adopted`, `image_url`, `created_at`, `updated_at`) VALUES (10, 'Milo', 1, '柴犬', 2, 'male', 'medium', '可爱的柴犬，表情丰富', '已接种疫苗，健康状况良好', '活泼，忠诚', 0, 'https://images.unsplash.com/photo-1537151625747-768eb6cf92b2?ixlib=rb-1.2.1&auto=format&fit=crop&w=500&q=60', '2025-04-27 20:20:23', '2025-05-13 20:02:21');
INSERT INTO `pets` (`id`, `name`, `category_id`, `breed`, `age`, `gender`, `size`, `description`, `health_status`, `behavior`, `is_adopted`, `image_url`, `created_at`, `updated_at`) VALUES (11, 'Luna', 3, '鹦鹉', 3, 'female', 'small', '聪明的鹦鹉，会说许多话', '已体检，健康状况良好', '聪明，会模仿人说话', 1, 'https://images.unsplash.com/photo-1552728089-57bdde30beb3?ixlib=rb-1.2.1&auto=format&fit=crop&w=500&q=60', '2025-04-27 20:20:40', '2025-05-15 14:51:36');
INSERT INTO `pets` (`id`, `name`, `category_id`, `breed`, `age`, `gender`, `size`, `description`, `health_status`, `behavior`, `is_adopted`, `image_url`, `created_at`, `updated_at`) VALUES (12, 'Leo1111', 4, '仓鼠', 1, 'female', 'small', '可爱的小仓鼠，活泼好动', '已体检，健康状况良好', '活泼，喜欢玩耍', 1, 'https://images.unsplash.com/photo-1425082661705-1834bfd09dca?ixlib=rb-1.2.1&ixid=eyJhcHBfaWQiOjEyMDd9&auto=format&fit=crop&w=500&q=60', '2025-04-27 20:21:07', '2025-05-15 21:16:25');
INSERT INTO `pets` (`id`, `name`, `category_id`, `breed`, `age`, `gender`, `size`, `description`, `health_status`, `behavior`, `is_adopted`, `image_url`, `created_at`, `updated_at`) VALUES (15, 'apple', 5, '12', 1, 'male', 'small', '111111111111', '111111111111111', '', 1, '/uploads/pet-1747329098828-561758545.png', '2025-05-16 01:11:38', '2025-05-26 21:48:56');
INSERT INTO `pets` (`id`, `name`, `category_id`, `breed`, `age`, `gender`, `size`, `description`, `health_status`, `behavior`, `is_adopted`, `image_url`, `created_at`, `updated_at`) VALUES (17, 'peg', 2, 'zhu', 1, 'male', 'small', '', '', '', 0, '/uploads/pet-1747329711212-149205238.jpg', '2025-05-16 01:21:51', '2025-05-16 01:21:51');
COMMIT;

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `full_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `is_admin` tinyint(1) DEFAULT '0',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`),
  UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of users
-- ----------------------------
BEGIN;
INSERT INTO `users` (`id`, `username`, `email`, `password`, `full_name`, `phone`, `address`, `is_admin`, `created_at`, `updated_at`) VALUES (1, 'admin', 'admin@petadoption.com', 'a.gX2KI/hesXSb7iyoXCQteaVaVFdOp2q', 'Admin User', NULL, NULL, 1, '2025-04-27 18:57:53', '2025-04-27 20:33:41');
INSERT INTO `users` (`id`, `username`, `email`, `password`, `full_name`, `phone`, `address`, `is_admin`, `created_at`, `updated_at`) VALUES (2, 'wuxin', '1342280445@qq.com', '$2a$10$a8PAXk.BmOYgQtcfOsBSkeJHkaYrlTAFmo2K.L6NhJZs6gkiXqkri', '小陈', NULL, NULL, 0, '2025-04-27 19:16:42', '2025-04-27 19:16:42');
INSERT INTO `users` (`id`, `username`, `email`, `password`, `full_name`, `phone`, `address`, `is_admin`, `created_at`, `updated_at`) VALUES (3, 'testuser', 'test@example.com', '$2a$10$jH26GMylmEZHA3yjkWyloerRxbE7bdVRdnHpAV7BLMew59FAPDwe2', 'Test User', NULL, NULL, 0, '2025-04-27 19:20:05', '2025-04-27 19:20:05');
INSERT INTO `users` (`id`, `username`, `email`, `password`, `full_name`, `phone`, `address`, `is_admin`, `created_at`, `updated_at`) VALUES (4, 'testuser2', 'test2@example.com', '$2a$10$xU.czIIklw8stG00SJwXYuyfYLB1NASege2o2HyQdVDdnF259wtMS', 'Test User2', NULL, NULL, 0, '2025-04-27 19:21:25', '2025-04-27 19:21:25');
INSERT INTO `users` (`id`, `username`, `email`, `password`, `full_name`, `phone`, `address`, `is_admin`, `created_at`, `updated_at`) VALUES (6, 'user999', 'user999@example.com', '$2a$10$MdiQCxfwPhWhTFu1sL1g2u8BXJ82LtrOyKcu4U2ivgBk5NpbpoHwO', 'Test User 999', NULL, NULL, 0, '2025-04-27 20:09:25', '2025-04-27 20:09:25');
INSERT INTO `users` (`id`, `username`, `email`, `password`, `full_name`, `phone`, `address`, `is_admin`, `created_at`, `updated_at`) VALUES (7, 'wuxin4', '1342280446@qq.com', '$2a$10$nJ1QoJTs4zr2lSpbic9dZ.8rKo0cRjpnRTBE0LXMzorlSEmnBhJOu', '小王', '12345678910', '111', 0, '2025-04-27 20:11:31', '2025-04-27 21:49:20');
INSERT INTO `users` (`id`, `username`, `email`, `password`, `full_name`, `phone`, `address`, `is_admin`, `created_at`, `updated_at`) VALUES (8, 'superadmin', 'superadmin@example.com', 'a.gX2KI/hesXSb7iyoXCQteaVaVFdOp2q', 'Super Admin', NULL, NULL, 0, '2025-04-27 20:36:42', '2025-05-15 10:12:53');
INSERT INTO `users` (`id`, `username`, `email`, `password`, `full_name`, `phone`, `address`, `is_admin`, `created_at`, `updated_at`) VALUES (9, 'newadmin', 'newadmin@example.com', '$2a$10$tTyOGmoeeYmo58IWc7gAp.gX2KI/hesXSb7iyoXCQteaVaVFdOp2q', 'New Admin', NULL, NULL, 1, '2025-04-27 20:42:31', '2025-04-27 20:42:31');
INSERT INTO `users` (`id`, `username`, `email`, `password`, `full_name`, `phone`, `address`, `is_admin`, `created_at`, `updated_at`) VALUES (10, 'wynb', 'wynb@gmail.com', '$2a$10$3g2AQN5vZDOpt1fveYY1zu10RSqIeCZgKRxAc3cJYuR0NPbDJitQK', 'wy1', '13687012059', '111111111', 0, '2025-04-28 10:01:55', '2025-05-15 22:00:37');
INSERT INTO `users` (`id`, `username`, `email`, `password`, `full_name`, `phone`, `address`, `is_admin`, `created_at`, `updated_at`) VALUES (11, 'testuser4', 'testuser567@example.com', '$2a$10$pdbnUKZocEms6P3LLRZz3OHuNmkRzLNS3lw7KCoDVdpdCAFUu.rhm', 'Test User', '1234567890', 'Test Address, City', 0, '2025-05-15 21:46:10', '2025-05-15 21:46:10');
INSERT INTO `users` (`id`, `username`, `email`, `password`, `full_name`, `phone`, `address`, `is_admin`, `created_at`, `updated_at`) VALUES (12, 'wuxin1', '1342280345@qq.com', '$2a$10$Ah8NxwOax4iHWMTyrqcYh.tlhPl5lXUCDwAjp23DY3AqLdExhyQxq', 'xiaochen', '111111111', NULL, 1, '2025-05-15 21:49:55', '2025-05-15 22:00:05');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
